Hi all,
I am having an issue with a performance point 2007 filter. It is based on a hierarchy of 4 levels. Total amount of records is under 500 (about 450) so i shouldnt have the filter limit issue.
However the filter is stopping about 3/4 the way through the list on our production server (QA and Dev are fine). I have looked for the filter limit in web config - cant find it on any server.
So I have run SQL profiler on the cube while running PP. I can see the queries come in and its splitting the filter query into two queries in exactly the point where we are seeing the missing data.
Any ideas why?
Many thanks
Dan